gsm_user table — gsmus
The gsm_user table is the central table of the User group. This table defines the users who can log into the system, in other words, the approved users of the system.
Table 16–1 lists the table’s FLA, fields, and foreign keys.
Table 16–1: gsm_user table information
|
Table FLA
|
Fields (data type)
|
Foreign keys
|
|
gsmus
|
user_obj (Decimal)
user_category_obj (Decimal)
user_full_name (Character)
user_login_name (Character)
user_creation_date (Date)
user_creation_time (Integer)
profile_user (Logical)
created_from_profile_user_obj (Decimal)
external_userid (Integer)
user_password (Character)
password_minimum_length (Integer)
password_preexpired (Logical)
password_fail_count (Integer)
password_fail_date (Date)
password_fail_time (Integer)
password_creation_date (Date)
password_creation_time (Integer)
password_expiry_date (Date)
password_expiry_time (Integer)
update_password_history (Logical)
check_password_history (Logical)
last_login_date (Date)
last_login_time (Integer)
disabled (Logical)
language_obj (Decimal)
password_expiry_days (Integer)
maintain_system_data (Logical)
default_login_company_obj (Decimal)
user_email_address (Character)
development_user (Logical)
security_group (Logical)
default_security_group (Logical)
|
language_obj
user_category_obj
user_obj
|
Table 16–2 gives details of the table’s indexes.
Table 16–2: gsm_user index information
|
Index name
|
Elements
|
Type
|
|
XPKgsm_user
|
user_obj
|
Primary Unique
|
|
XAK2gsm_user
|
user_login_name
|
Unique
|
|
XIE1gsm_user
|
user_full_name
|
Nonunique
|
|
XIE2gsm_user
|
profile_user
user_full_name
|
Nonunique
|
|
XIE3gsm_user
|
external_userid
|
Nonunique
|
|
XIE4gsm_user
|
user_password
|
Nonunique
|
|
XIE6gsm_user
|
default_login_company_obj
|
Nonunique
|
|
XIE7gsm_user
|
user_category_obj
|
Nonunique
|
|
XIE8gsm_user
|
created_from_profile_user_ob
|
Nonunique
|
|
XIE9gsm_user
|
language_obj
|
Nonunique
|
|
XIE10gsm_user
|
security_group
|
Nonunique
|
The main user details are contained in an external security system, pointed at by the external_userid field. This table defines extra user information for a system, and allows a user to be optionally associated with a person to enable the entering of other data, such as full name, address, and comments.
There is a logged-in flag on the user record to enable the identification of user availability. Users are available if they are logged into the application.
The existence of this specific user table in the Repository also aids automatic referential integrity.